package top.javai.www.dao;


import org.apache.ibatis.annotations.Select;
import top.javai.www.pojo.JobAndTrigger;

import java.util.List;

//查询所有定义任务相关的接口
public interface JobAndTriggerMapper {
    @Select("SELECT " + "QRTZ_JOB_DETAILS.JOB_NAME, " + "QRTZ_JOB_DETAILS.JOB_GROUP, " + "QRTZ_JOB_DETAILS.JOB_CLASS_NAME, " +
    "QRTZ_TRIGGERS.TRIGGER_NAME, " + "QRTZ_TRIGGERS.TRIGGER_GROUP, " + "QRTZ_CRON_TRIGGERS.CRON_EXPRESSION, " + "QRTZ_CRON_TRIGGERS.TIME_ZONE_ID "
            + "FROM " + "QRTZ_JOB_DETAILS " + "JOIN QRTZ_TRIGGERS " + "JOIN QRTZ_CRON_TRIGGERS ON QRTZ_JOB_DETAILS.JOB_NAME = QRTZ_TRIGGERS.JOB_NAME "
            + "AND QRTZ_TRIGGERS.TRIGGER_NAME = QRTZ_CRON_TRIGGERS.TRIGGER_NAME " + "AND QRTZ_TRIGGERS.TRIGGER_GROUP = QRTZ_CRON_TRIGGERS.TRIGGER_GROUP")
    public List<JobAndTrigger> getJobAndTriggerDetails();
}
